package com.green.voluntaryfiling.mapper;
import java.util.List;

import com.green.voluntaryfiling.vo.MajorDetailRes;
import org.apache.ibatis.annotations.Param;

import com.green.voluntaryfiling.domain.UniversityScoreByMajor;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

/**
 * @Entity com.green.voluntaryfiling.pojo.UniversityScoreByMajor
 */
@Repository
public interface UniversityScoreByMajorMapper extends BaseMapper<UniversityScoreByMajor> {
    Integer selectMajorLowestRankingByKobetsuAndMajorLowestScore(@Param("kobetsu") String kobetsu, @Param("majorLowestScore") Integer majorLowestScore);

    List<MajorDetailRes> selectMajorWithName(@Param("university_name") String university_name, @Param("subject") String subject);
}




